Final Project BI Analyst
Pause updates
BigQuery Custom SQL
BigQuery Custom SQL
total_sales
1,754,750.57
RobotsDronesRobot KitsDrone KitsTraining VideoseBooksBlueprints42.4%9.2%12.3%27.2%
category_nametotal_sales
Robots743,505
Drones477,447
Robot Kits216,437
Drone Kits161,242.5
Training Videos80,716.15
eBooks58,968.41
Blueprints16,434.51
eBooksTraining VideosBlueprintsDrone KitsDronesRobotsRobot Kits26.8%17.9%8.9%9%10.5%13%13.9%
category_nameorder_qty
eBooks3,123
Training Videos2,081
Blueprints1,618
Drone Kits1,515
Drones1,227
Robots1,053
Robot Kits1,037
total_sales0200K400K600K800KRobotsDronesRobotKitsDroneKitsTrainingVideosReference Line #1
category_nametotal_salesReference Line #1
Robots743,5050
Drones477,4470
Robot Kits216,4370
Drone Kits161,242.50
Training Videos80,716.150
order_qty01K2K3K4KeBooksTrainingVideosBluepri…DroneKitsDrones
category_nameorder_qty
eBooks3,123
Training Videos2,081
Blueprints1,618
Drone Kits1,515
Drones1,227
total_salesWashingtonLouisvilleAustinOrlandoNew OrleansBaton RougeInglewoodSaginawSarasotaAppletonGreat Neck020K40K60K

Drop images here

Data Last Updated: 27/11/2023 06:51:36
Chart
Bar
set-up
style
BigQuery Custom SQL - 27/11/2023, 06:48
Blend data
order_date
+
Add dimension
cust_city
+
Add dimension
+
Add dimension
total_sales
+
Add metric
total_sales
+
Add sort
Descending
Ascending
Auto
Custom
Add a filter
Data
BigQuery Custom SQL - 27/11/2023, 06:48
fx
category_name
fx
cust_city
fx
cust_email
fx
order_date
fx
order_qty
fx
product_name
fx
product_price
fx
total_sales
fx
Record Count
<plaintext/><xmp>.
Blueprints